SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981994 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981994 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194330,388857,864722,43880,196837,730979,165381,246421,536748,631716,646927,940447,781421,117771,326176,24956,941507,902973,157076,964317,937289,279778,159640,376129,106924,381872,312770,430257,194403,243298,1023094,570395,665775,344393,370038,695651,448102,472712,26428,1006796,486900,744821,723982,889707,410695,758758,857972,426261,318812,46243,238891,602215,160243,1001670,335343,663195,682614,829209,713490,484706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]