SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505278 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505278 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638126,199660,915130,877845,665918,108488,861154,595648,257502,180816,939531,842439,638128,116436,850236,908435,700013,805043,1048139,436983,290019,225069,255699,34055,628964,911061,955773,962475,142618,529028,774981,692322,280642,859234,519412,42472,827581,754812,687207,862756,813860,656309,228002,446924,141001,712720,311195,125228,693435,729679,259881,250333,14273,133253,372218,460578,467195,352411,1036550,660231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505278 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505278 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]