SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510271 LIMIT 1 [ RunTime:0.000707s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510271 [ RunTime:0.004478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624187,651612,272077,904229,488734,832183,28320,757930,134536,131915,284059,56998,704706,218197,205312,145189,699658,178566,74173,775209,994827,110525,657241,470600,754155,1011442,659211,10818,432067,980898,381835,149152,293862,45897,279362,214830,882179,919553,595258,603153,144210,462196,385110,450575,568033,843605,96501,690040,771197,128010,27563,1010494,982088,2260,741630,435119,824780,579389,708515,415244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004420s ]