SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310308 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310308 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189017,416478,884287,147856,560517,39649,860188,558130,1018675,105089,145897,263259,185970,88209,859014,904317,289394,438752,425349,729779,866626,720286,245472,91316,912745,7702,644810,288226,306937,592696,420931,280077,247884,370847,442799,823632,738537,95208,967026,320125,400508,427347,637363,287222,445415,89903,457863,729946,18521,535534,326174,549926,473018,1029357,113626,105534,555094,628520,595203,478552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]