SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114541 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114541 [ RunTime:0.002582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459847,103700,219276,925607,408434,565397,201514,900290,592073,430048,98315,418860,1029683,885733,258360,193483,951548,971841,562091,527414,1012347,276970,890268,526759,623078,37055,952506,800459,550322,1020416,792421,380188,163967,895106,837186,954208,640637,37166,266229,233565,869412,250738,597753,764219,646513,643314,185142,858507,586085,565988,74660,451074,477610,831310,117786,702048,962798,720715,496142,498431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000380s ]