SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534043 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534043 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996913,924850,569597,667714,341397,499647,554865,954142,395295,931100,620418,127137,406899,514844,749604,409240,495106,757859,920813,655499,716716,664512,344993,90234,415351,951889,808654,900747,585267,379918,539562,292404,249270,627956,999976,598409,410630,545102,723934,24650,817563,60850,923276,19073,150223,584258,976450,1012891,760811,560471,775014,723189,781281,441540,21084,785852,365382,792647,531058,968285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001145s ]