SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502586 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502586 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506678,303125,489422,49481,614851,539145,69765,47052,701793,637880,644683,874037,807005,319990,379495,344137,718016,863810,591314,765440,821176,894413,53566,1029977,482150,776181,91112,732948,496580,278309,908556,252680,976094,441459,1008239,929292,146707,62520,375431,892859,30092,495910,185494,509416,290068,187991,923651,575902,465966,979005,954103,389888,963783,1046705,1046270,625521,468382,894798,305175,256518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502586 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502586 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001193s ]