SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413553 LIMIT 1 [ RunTime:0.001705s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413553 [ RunTime:0.003610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736768,21840,1019757,598099,293320,12966,766662,866005,418167,41019,1047867,681138,66976,216772,135477,122752,652152,328538,819729,1018809,437800,438127,336430,326574,886853,263071,151749,323513,494548,972586,1039603,375596,728987,473957,129554,105824,377086,812679,864838,618389,90605,543807,877115,261568,634547,475418,902023,978858,904413,37632,761407,358784,121547,280831,185593,210817,982448,231018,467679,862074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]