SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334913 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334913 [ RunTime:0.002079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439437,790479,574812,238137,406072,830315,439925,826807,546402,210561,26870,131089,361163,1039735,1020978,488059,155619,950817,779680,477303,185584,303394,904961,25166,28124,564528,484703,920020,508926,248736,303942,824343,990059,466822,676123,246360,365388,59426,118213,316599,522644,85745,656820,103331,744755,210646,667203,414054,225343,404601,26651,594962,882412,362676,821675,619779,972179,922890,471966,943506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]