SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 37511 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 37511 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019138,582323,404316,421526,826431,224487,323580,204879,402768,703014,181391,586086,850114,899630,487771,828646,450813,12608,105716,162506,84219,49779,967075,220392,285423,394714,372123,697070,8940,701793,558474,11512,704501,960705,1026858,571264,704895,502822,67992,254769,785507,265620,706769,9964,930758,291199,1044856,992987,979764,509162,966383,438126,326211,303868,354603,195885,592290,988849,120445,118579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 37511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 37511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]