SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195910 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195910 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862781,14383,72754,899208,1025600,900823,10353,879262,779840,103850,445385,419582,788157,658957,310256,405489,306060,19741,1003127,1045593,673516,252918,156214,118866,944064,226237,374639,725112,509397,839914,434506,129616,411985,486116,814884,586145,584946,892751,987643,459679,60122,465866,634495,727463,648047,628588,915977,178930,819148,734487,865829,413163,875630,731657,904492,863677,894500,787545,829597,288527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]