SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 909501 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 909501 [ RunTime:0.003528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958146,124118,689839,566871,888435,314309,853683,911081,913005,1021344,627302,104257,353582,470293,213382,1012119,420560,49695,741926,950836,301292,310678,248491,370854,95575,955749,91556,614412,907759,491591,836145,363777,573343,1015804,104454,755361,684811,980804,662542,279977,722119,1001584,673195,75537,803968,650150,195037,246758,1005242,1007850,809562,440146,644884,753267,364193,786103,157264,742573,917223,1008317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 909501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 909501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001532s ]