SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042638 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042638 [ RunTime:0.002091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643845,814226,1003052,229364,580850,221012,251709,22111,722109,305959,713088,1014456,534888,40311,369330,517362,272119,93119,433234,59948,380430,198680,855134,887353,1004990,415858,313997,458730,756361,39094,428724,381445,550616,1019293,377771,966088,809165,434355,811375,912365,619083,945443,590715,814222,31329,368375,458145,841586,292662,644886,313220,881924,831269,650523,436776,822219,786128,519165,991737,285392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]