SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507508 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507508 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536178,572423,81611,289976,893200,908151,1047018,612413,848256,423196,63941,648015,58746,174088,751342,360526,735829,447867,793120,1021676,350166,1036866,215603,601738,572873,896871,734546,209538,828142,946375,53766,299403,724628,1042371,883160,830140,764500,431373,43931,223820,29720,1048021,479999,243516,902285,388900,994475,685526,846486,127968,912930,780288,962412,731124,509880,45663,361207,113002,904810,151482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]