SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203390 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203390 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259517,1024359,760489,416176,574842,683140,521457,434543,464057,724797,900685,475866,511126,754965,747874,554184,723499,383246,471487,398568,213123,975374,985497,10200,832381,805193,403307,653726,314621,279657,492114,403151,493831,77696,183229,590785,924979,601601,45640,756688,700525,555417,507963,730076,312206,684708,456662,543453,380364,769950,945673,914091,251944,637976,860366,383464,350578,900433,635841,203692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]