SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507544 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507544 [ RunTime:0.001412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288089,850910,573149,1022129,503734,294714,507517,880123,636198,230732,559203,828944,863957,219646,118438,467394,501766,20375,732781,591108,1005887,600948,15806,980330,758809,958266,534405,247305,643967,203071,727229,404311,584837,998712,192421,582778,559606,688089,567357,130975,191850,338984,727409,140785,361823,753984,33194,981388,150149,323963,436317,564251,41413,334385,965402,878487,141888,155370,52152,126401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]