SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005731s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244581 LIMIT 1 [ RunTime:0.003598s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244581 [ RunTime:0.009770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517069,46396,629198,870280,621966,810946,945332,762314,345630,569700,840159,725692,802063,65723,248548,64098,158577,169844,313400,111538,800700,690491,794331,1014503,64688,356191,945708,328770,505061,758170,800847,69396,688062,243105,679774,656569,83516,463483,236993,827242,622001,279514,766423,77830,903332,1013411,352463,424410,879340,1020934,101451,853364,975448,834528,339293,943291,149919,205235,361252,556898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.010073s ]