SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50978 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50978 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989891,648572,354059,611317,458066,896763,812822,293202,638634,410029,741695,487345,459568,701422,124129,57511,933157,686500,317768,934823,944948,676720,641066,353992,220558,573587,1002607,873140,358221,200863,1019368,919054,572958,202843,787931,97491,477083,101127,888541,75064,760731,539243,942177,523554,23732,41820,964204,480186,987163,273058,23668,975507,309472,1021491,456067,483482,430663,287242,880688,454260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000826s ]