SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436699 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436699 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551234,589102,791594,690155,940702,171683,803353,397606,398968,296303,566762,365465,968512,483350,39143,129055,24442,405569,93073,605011,44861,164519,668775,838685,562847,238112,1031202,518179,1005492,1034080,725854,404234,157846,26538,352229,964204,882791,103433,917932,282477,761733,722184,79330,1038350,858577,305651,1000243,493745,178408,611763,770251,430888,430388,112707,465870,101445,458237,680809,138190,29566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]