SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477412 LIMIT 1 [ RunTime:0.001312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477412 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185232,648871,128807,1038610,883628,1031614,504627,1030209,589720,96788,604547,877086,1005161,487193,429827,263794,36212,210301,199055,406268,256015,20723,957182,45576,642682,835675,512585,406998,473907,197633,520518,141522,800704,653931,372809,180026,544987,664383,581224,147514,777883,1008927,505415,75300,635717,67405,299919,505285,350617,55322,295812,392535,383554,122349,551974,31549,602264,318879,259218,287557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]