SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44454 LIMIT 1 [ RunTime:0.000890s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44454 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277527,435630,55526,501062,295797,718746,967943,381312,538205,392634,775651,279096,406456,871143,63207,519606,772821,243718,793629,30542,454887,522852,905396,182456,123438,1023760,386663,958296,957497,18355,472054,369664,348927,850389,356231,509056,214220,246357,691760,54332,434339,277712,389008,585450,516037,558474,4421,170576,321884,672891,304242,88887,869152,561862,391175,21590,317469,544304,922704,300636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]