SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453194 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453194 [ RunTime:0.002862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015294,347493,302935,233145,236830,910452,365363,37773,449616,685546,316945,191717,180200,425548,26205,393250,175984,550324,750005,580337,602078,665767,737330,660652,679118,480846,475873,436695,660166,509930,278900,16340,337393,1023363,825154,332789,755375,854532,356639,871683,82537,702176,267449,339916,498758,188223,888049,437580,1030606,754534,154692,435128,450212,525851,731668,760931,462587,893785,846503,833743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]