SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41209 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41209 [ RunTime:0.002827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743876,799808,961236,794345,119311,881260,461201,567383,804204,589675,358108,386863,331000,484117,418247,704466,674387,484034,834758,700519,198161,785455,304000,70790,365714,591322,83656,481193,341068,255760,791330,352288,784954,55360,333738,53208,891282,768586,50225,641820,417960,538386,887202,946035,856849,455150,880337,1048793,165696,741721,556355,356383,854352,578644,283966,102859,102433,465689,317970,681691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]