SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331911 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331911 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772429,78859,702626,359971,576822,648501,741749,679446,392005,899012,637488,602222,1041424,941285,588027,842638,1047712,324585,416119,771237,658252,909965,300206,382103,770157,48695,991514,762996,597699,235766,229251,693611,712832,246732,110060,544700,985032,598087,800051,281739,781810,442995,399740,978124,354334,236062,189599,800637,84123,970532,35347,323093,189187,661036,1032459,140833,453805,364942,603341,822768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]