SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 719999 LIMIT 1 [ RunTime:0.001391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 719999 [ RunTime:0.002734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323672,459336,171313,1044456,10608,567170,891863,462996,727769,171008,757427,22875,959345,148273,661890,558838,1015213,845483,958587,754840,761593,261975,655239,1025838,444338,518076,317803,343725,936542,705293,540743,238503,768481,870256,538300,562179,109826,312300,873787,47897,132846,499242,469157,22372,739500,314972,945629,676184,475936,801072,313023,541653,257074,748410,327975,905335,261941,282098,496536,785579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 719999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 719999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]