SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018861 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018861 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354005,110136,872920,757025,1013875,921840,105906,145010,182980,996174,219049,738601,734973,653028,103540,561670,779811,902783,975217,627815,277342,378829,665011,650572,328786,244851,317075,481500,278832,154320,474983,785129,994115,212665,630172,966479,302206,354976,25302,991495,533714,967284,582647,851357,740698,1673,438277,706415,299154,240686,653925,111772,523518,538903,143708,649323,368529,390924,4596,840821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]