SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569800 LIMIT 1 [ RunTime:0.001147s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569800 [ RunTime:0.005043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366561,688066,660023,353180,118776,453958,922132,837894,1028211,733882,858369,394376,486207,460194,728480,766465,241641,5955,1017151,358741,268982,67397,411145,865258,1024996,742812,1038383,112276,1033361,832764,959565,795732,16027,821098,917646,613771,206635,443588,215062,69354,483958,74015,411291,863454,292228,42370,1048464,972817,984525,560166,1004085,272155,250648,846526,173900,334304,544040,167709,1043960,869815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001150s ]