SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354206 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354206 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446995,366973,985507,934094,818899,266429,789524,1030998,171149,917968,1028806,399988,3211,897500,152672,451724,925286,887651,612896,885407,137815,965957,121912,830829,951351,410161,909726,51624,8164,293887,325399,946437,676396,891096,137436,714384,503381,936787,724977,544196,742063,794545,151168,81759,156493,38823,552088,820046,47744,688468,659961,725281,395764,492394,120425,124366,9149,334974,187920,1008125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]