SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50941 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50941 [ RunTime:0.002336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61724,230670,839533,907600,695741,240888,1018745,248986,543571,367294,329194,378288,681069,758475,388572,950965,304003,307897,459949,631872,242905,797015,811984,442873,751617,48115,435971,33700,322875,162381,752205,330656,480998,356414,107759,59945,34144,733454,36073,414749,248301,1005485,169380,329882,794526,363417,289730,679153,98876,404212,325675,12229,210272,946792,718688,201640,264482,656366,187266,126591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]