SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001618s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39442 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39442 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (867263,136691,606482,368608,858224,785535,395245,845289,636118,839481,376903,177809,962775,673594,576411,615042,1019045,166411,313913,21870,84649,347093,676478,457872,76759,410169,52183,24270,716034,620328,106046,498837,822257,509081,57834,32906,273171,177711,464394,165553,254085,220472,21740,924648,815126,215975,297616,81944,76273,243581,721829,129734,550905,236300,475311,244645,459565,937247,955245,1001543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000840s ]