SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671063 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671063 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (227700,267808,325335,515269,406647,899677,561632,387427,828358,971053,279462,998427,780334,672639,200008,802421,148454,661557,224970,486646,638690,551796,543046,1010015,613033,363809,707100,646170,692666,777596,926450,520997,972114,468537,171191,758808,141556,783835,170816,102639,811797,310790,469884,265377,786096,26579,484550,698679,2859,685290,609594,618471,563456,787490,195438,253941,704484,835324,600938,332525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]