SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002419s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401647 LIMIT 1 [ RunTime:0.000846s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401647 [ RunTime:0.002135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60810,124654,167570,724004,63541,353033,489043,664439,429836,502059,172838,586992,117985,345473,156981,566410,507552,49439,572779,419424,1043395,496558,748010,1013166,510492,606044,1040444,893812,752897,190909,95031,958785,910498,700826,533096,763628,177998,649651,583470,886430,58734,216944,96701,902584,722337,202450,502047,1043983,928885,616461,952206,216363,597198,289359,342393,624778,919120,219956,269976,824193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401647 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401647 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]