SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296006 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296006 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395300,330137,911374,861205,305410,700602,26895,9991,889795,367478,321516,46431,639940,542867,356303,490120,903317,353328,393241,817428,87895,770036,264899,529086,283586,136040,84551,152240,603815,799293,999969,792653,89950,530442,42649,828218,884332,986424,65233,682436,508462,242013,427254,132842,700378,84515,598472,191678,67799,1035489,739962,793253,150075,955938,581916,509113,263580,790836,958246,363611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]