SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584454 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584454 [ RunTime:0.003465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112697,140669,713684,423118,1036992,232011,783954,742460,407775,326186,849086,660590,784079,42126,895071,87183,284980,1048755,403600,804308,524670,606695,692929,200458,308151,1021577,128849,556312,324338,566580,767833,126857,462425,949631,1011351,357535,997151,696874,296554,517712,911673,717485,152932,974034,643883,962391,922228,354285,1023123,659268,16960,1030481,254367,527579,291965,946798,864491,182569,604148,739705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]