SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017856 LIMIT 1 [ RunTime:0.001346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017856 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301034,971222,64117,437708,973864,718115,307572,31503,718581,550622,318101,160247,396339,13159,219626,1021018,899975,200670,988105,929587,547393,300012,877747,269363,1015843,810909,708541,901809,152629,1037034,699594,450947,982305,338234,820893,930073,134703,914444,1029636,362784,276902,65518,160172,583358,228924,400994,48156,869963,419709,555221,880158,389663,829287,721986,453980,308575,1042659,546461,74021,577378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]