SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400371 LIMIT 1 [ RunTime:0.000836s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400371 [ RunTime:0.003202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852393,1007216,189401,147456,635437,390313,513101,137992,519970,969267,542260,982593,609721,359278,52616,749693,408633,672880,209548,891178,523912,50477,7318,191147,789021,1000679,150347,249947,879327,1022120,416799,700568,205903,338685,102299,619331,432067,213635,971990,489878,855449,299827,499080,656270,685740,65680,627107,461727,247101,798399,818979,342820,532583,290603,655321,546549,465710,795638,159689,255260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]