SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610198 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610198 [ RunTime:0.001504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871744,33560,513708,258421,623003,599870,553679,772093,134621,454487,150280,827408,800684,150205,548003,830633,531318,871371,382624,129586,242432,683938,148548,598434,546492,289929,743580,593040,449475,571252,399824,322591,780484,312394,449924,105245,325824,991999,402407,825919,596379,503332,575199,997345,211536,408771,87978,582564,82080,706754,768812,926928,157915,657592,252025,3912,382298,260842,127047,125802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001820s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]