SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262679 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262679 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619494,1012368,183289,258950,119974,159358,100098,375686,740501,752070,920601,695657,589848,824066,562066,135456,592770,182017,804656,187026,416688,952056,439488,1013736,197420,117601,574566,712353,169380,580521,1038031,356759,723788,58705,769410,349927,439353,561583,166723,866327,99814,825431,778273,214032,66068,650323,139825,460937,626771,989608,660269,771240,764520,763411,936118,329836,440024,474791,1040940,298032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]