SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51891 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51891 [ RunTime:0.002587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840413,213821,150426,1023667,748115,126505,560383,880977,280411,770776,265314,125002,15084,224240,425729,649492,661121,423344,164273,698138,450684,437725,139296,913262,194857,828725,26029,857764,1016465,52807,852020,81310,843566,217510,671609,729162,970262,532972,348985,959450,441498,461910,328211,791268,295156,632886,587408,905660,134072,342771,2224,35054,389008,335317,897400,238603,865822,231319,532353,382358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]