SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003867s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503721 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503721 [ RunTime:0.005193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132996,22487,900788,1018132,531677,18197,856751,731580,171896,903039,41236,94633,896757,390043,703445,400905,163763,503660,289989,268074,257558,103834,905102,249783,777676,334576,1038173,335641,699744,360690,284675,663931,475726,169963,63422,831853,678123,839471,776862,752044,670337,153747,615135,669226,591877,83138,11687,318589,373179,914525,627487,256103,12134,491265,283017,908555,511745,976065,277209,1037358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000786s ]