SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017213 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017213 [ RunTime:0.003502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912886,797985,539114,543097,461628,213759,767881,1020177,262971,239283,527908,47791,878376,753144,620473,881539,666601,1046715,50278,102590,723349,864504,524513,558531,1021633,306296,424807,684548,278546,912345,23652,271622,414801,527882,889781,161707,1013767,653459,134867,177714,16750,620762,939954,693641,835041,1039198,718526,580146,786008,94408,447097,516116,155679,332598,3155,51624,309286,664921,713946,542465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]