SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4753 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4753 [ RunTime:0.002128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109773,320814,68374,359013,679872,160652,26666,198815,371906,879007,306171,719228,802710,625690,435231,160656,142017,81886,82539,947982,183795,198063,552027,670550,536382,237524,20815,83523,320661,467259,580982,814085,960624,787165,248207,784525,597146,858443,1008466,994273,494592,722746,29839,365739,802576,864586,566092,411101,71411,967790,555102,110343,333076,421233,575662,132790,635324,1018825,1047455,885367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]