SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543257 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543257 [ RunTime:0.002671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470136,284241,211988,629199,366565,624015,841313,991771,177222,792963,970996,232255,330398,934582,887019,206666,462614,782608,686094,387774,590610,678513,577634,481148,540339,524749,663662,792866,31388,226564,61127,426311,855610,20850,198278,518365,365608,116301,132436,603775,380202,534363,909847,947976,783888,304437,203439,533186,674638,553303,270240,89759,51947,59521,379764,990768,357405,921343,768220,385446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543257 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543257 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]