SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433143 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433143 [ RunTime:0.001434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205492,182420,218404,208489,90755,823653,921371,302830,885827,392783,1014576,752635,175744,777472,429986,597236,81680,997737,661639,221851,340704,830728,140573,978320,963650,416919,344879,179787,43511,464186,813104,313365,836394,663654,976336,270770,249541,942882,391191,398620,940167,626916,265169,119040,594690,328575,757798,418691,109255,905360,911480,785146,72352,258139,81869,53614,457141,133839,239737,522067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]