SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482343 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482343 [ RunTime:0.001411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967408,419083,991493,868602,727637,391378,497133,458665,30584,610274,268485,156814,8196,415718,561987,307316,252800,937963,731730,20886,240260,494091,189682,930465,883263,825288,290690,370504,132145,5247,261317,435881,249929,488021,600392,481898,387520,648026,28687,366417,172998,307258,367698,741506,707099,955884,238491,99260,1041024,173346,1037792,932557,804113,479793,467766,78518,538456,585583,420051,23482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]