SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028888 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028888 [ RunTime:0.002962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823630,403527,424916,819876,978476,819828,637394,609695,197952,201440,269755,841288,738429,1007647,10,384379,614136,659650,93250,1020867,338693,432993,509465,354843,422537,272321,226812,808602,583813,276324,990160,1035227,157316,106324,255336,130169,507913,202673,43454,592405,1030875,586280,753145,253603,873533,709654,775066,995453,466293,652855,984886,587785,378710,945458,668362,782000,968555,443382,207373,964616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]