SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403495 LIMIT 1 [ RunTime:0.001233s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403495 [ RunTime:0.001439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266202,279070,343025,999373,466915,419979,711180,1037960,687035,261786,212444,561303,939970,616481,851274,395009,522883,184039,266449,989679,386079,1042221,109998,144467,260659,262419,503059,853707,726247,511528,966204,949126,873186,446067,679516,897925,975142,124021,336874,497288,523121,418134,784132,261701,940224,963225,894666,347762,784682,670864,440011,121817,107373,624117,941863,674638,956438,128796,815451,127548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]