SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036548 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036548 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255659,506107,501568,398251,276759,362431,928355,511162,769235,705886,88862,502110,210079,704407,770045,236255,1002219,636417,446540,733357,85504,800206,682496,966536,291119,343844,673558,931238,801309,125995,774725,202606,997200,321173,992141,536514,113862,796125,934011,293225,450335,856086,549489,721126,195819,475240,989684,876333,317008,7714,710248,415745,142315,362536,232394,394284,113325,848638,782847,337699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]