SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395706 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395706 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353501,46487,206822,610702,23101,1037959,792743,192963,450834,404016,934542,757658,332009,357628,746036,905385,480013,280877,561075,363200,372961,493824,323918,350931,331970,796264,681292,7431,182934,220548,953599,21703,633859,483379,430885,20100,848358,344711,256701,214793,35327,545224,487775,572347,684065,910875,804924,688340,583214,188924,342950,390211,231227,692776,766033,388802,299633,807135,771585,829550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]