SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 813700 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 813700 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513272,491113,1028023,192840,472676,204969,1039059,678041,90884,686395,189973,94768,501073,316698,313068,437515,250717,414858,680960,994380,105714,1005168,65330,679176,1045336,545319,330846,739933,191956,978597,703012,65109,1024060,253396,74478,851845,905497,713724,252019,820503,455225,641881,586823,657234,9635,751843,814292,747416,133215,451399,748842,1033895,318582,249173,1005941,892185,88823,792363,854527,455893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 813700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 813700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]