SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44662 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44662 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61843,83301,203546,235993,912199,648142,142565,545278,1017060,790861,439068,294980,787387,100267,20220,999057,805847,1009346,463990,836495,309759,296297,772242,849271,596453,166024,613586,790093,273594,136217,963186,493432,448000,318034,243501,134836,486738,511312,991954,559585,149029,609213,311551,574260,1017162,417860,957138,768303,353161,44481,199847,589507,1042247,42735,331470,339043,80738,24538,292087,632613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003890s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44662 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44662 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]