SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540808 LIMIT 1 [ RunTime:0.000641s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540808 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265829,632154,734953,42694,486863,46933,432025,662037,395468,700617,1005803,481462,905996,1020463,80618,700693,248406,24908,925635,707803,696974,825834,824240,685489,368412,758823,39015,573934,1026393,20859,1036083,343474,390093,425741,73381,390776,1033347,370213,559577,478450,865880,1028312,43994,653456,820170,647328,245565,677116,703367,261950,985843,49407,226209,983833,608898,1015383,511615,937853,418467,964397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002878s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]