SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038092 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038092 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028503,752357,571191,168890,442520,3639,585078,565948,111499,636103,455521,861919,792847,545006,619373,634765,717498,1011435,291071,407809,133114,324776,588166,1003395,929074,281397,694577,383782,69082,14267,223740,772982,38522,497027,264780,939527,260071,71334,847702,525731,418823,1029450,927178,730874,766806,59577,545069,797085,922728,465091,986411,497324,152018,119308,1000486,388125,584255,153762,446637,467235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]