SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537308 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537308 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442013,785197,389395,677616,697420,378205,607882,583930,200715,225519,805342,164203,123675,341824,579566,257384,964943,326590,472584,805834,920740,454092,902103,490092,532478,358042,145782,227942,757,51725,741196,918939,758762,525529,25917,578342,437773,132871,667804,395402,798260,1041920,329866,718799,890687,221737,608074,860366,233601,512646,912046,724815,214648,873631,112104,711750,495221,627480,361565,384522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000779s ]