SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455302 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455302 [ RunTime:0.002053s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599341,233284,607410,883328,276012,762755,954873,680182,282721,931829,990203,231827,392074,443972,329183,617907,675141,213002,696930,891222,782670,676930,651778,764027,722506,257192,427164,930442,338754,213463,975668,737426,535394,816988,132245,996152,766314,1022866,802561,212673,358595,85769,559831,650271,428748,395101,392563,605954,780699,410511,2709,1016118,723135,1019210,665065,609628,931417,628424,620182,1047493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]