SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428045 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428045 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928547,523162,29503,1044618,46279,205206,151799,602012,847555,767492,207122,125954,648848,975075,277795,98927,133095,419179,567342,220966,282813,291466,164533,842846,371553,465910,541362,575826,333492,996379,148506,842463,265336,322435,887076,950120,578797,382092,726440,222566,872014,534322,366720,109972,1019776,645622,576972,14058,539065,201101,900597,142517,272358,342901,623923,91036,578235,1012710,625519,74971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]