SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 829571 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 829571 [ RunTime:0.001296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116620,371779,839335,94270,761164,272199,504729,837039,778613,273574,313819,842784,461440,988489,997510,394654,564755,118350,823372,160335,653913,1045723,671564,162237,397521,302061,235527,475129,32245,340605,1048663,255775,106434,488083,443985,815024,77126,260846,113531,327823,109609,708201,59670,4318,822485,1043784,373614,722358,921505,249795,913079,915276,837372,843141,146209,534901,584284,639125,562982,100224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 829571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 829571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]