SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403780 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403780 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757825,690509,930716,684239,192079,905544,1031189,20961,674493,297900,446408,175775,536056,446236,276727,798171,110155,741229,859115,681609,150319,886851,99804,843476,328073,710745,523298,448361,754258,8559,778925,303414,288030,1016538,1037458,150623,808366,647039,375644,471427,1016610,766665,1039820,990459,568793,721386,930947,182005,954653,189177,675312,970550,316164,365895,594231,981830,437740,269664,409063,1020816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]