SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017961 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017961 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247489,438534,328499,1005335,216420,582282,369010,351852,1015040,335580,1020863,694977,905042,779330,446720,138074,314579,682900,358280,70790,513422,796839,156943,560845,788996,73609,920892,906781,408081,1018984,468103,162367,172174,148378,546010,370140,191031,699105,610973,102704,548451,894661,899649,489154,270410,572151,1040971,735857,704754,981464,752572,922372,670042,960728,149311,771345,643434,546540,314052,793604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]