SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003788s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286804 LIMIT 1 [ RunTime:0.001903s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286804 [ RunTime:0.003141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753281,408411,996582,6981,809960,527447,697104,283051,263466,385953,109750,990127,337026,64456,45600,77131,974138,103723,181654,319298,1043771,994760,501596,986490,529981,120690,941954,788548,736415,831893,408744,890993,531218,546077,104544,137031,451577,736881,775753,857704,1031267,522179,934005,26882,207004,937530,983867,746973,582172,803675,424236,35681,387233,844354,382301,24270,263897,993384,791875,239388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002280s ]