SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405209 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405209 [ RunTime:0.001473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827653,574874,643469,1040551,37178,353882,527736,472680,336489,95901,977839,761667,123976,1035074,92628,474787,79613,606129,231676,885079,2450,545633,665354,342713,1012999,147608,680380,303741,59100,1027526,754512,973212,299089,392927,458904,445404,586252,244697,129457,178568,134335,764287,118322,485692,110031,255784,860078,499826,1005410,927097,711240,52180,748987,93194,738461,148669,313383,343309,208196,871940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]