SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532364 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532364 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452250,79416,694236,328520,537351,906803,560621,494279,1004771,203645,845228,299593,601848,874644,498851,592696,137728,955997,1014352,142017,728083,1744,573304,445844,610315,525130,188996,323331,843877,541753,123608,766423,1043677,471180,366751,435425,464847,907294,42715,828522,332124,871021,99150,507388,702956,786256,300928,611685,785052,1037738,597071,424648,289777,985696,863855,687681,122913,347900,546445,492302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]