SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104571 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104571 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364242,94945,909853,498590,688857,145111,555593,321213,963816,471139,317570,467341,642850,524880,276239,353359,883922,195001,976208,96149,94981,337983,56297,472649,44506,142723,870109,848811,358198,537153,949843,922091,576318,120503,949838,834157,180448,793409,184894,978458,1016604,634398,52725,273708,589820,906729,230849,501766,293391,833041,904699,956678,270139,437003,726634,735049,189067,599364,180231,504983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]