SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454399 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454399 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559078,864127,881141,663559,25893,439128,412739,640927,106664,1037986,286488,14754,434938,475982,771840,124972,603965,5930,526027,337133,420657,525593,13634,243140,462010,607303,669075,17859,313456,893001,558270,994403,271661,606193,50694,411090,685031,70948,588725,398677,409095,42888,530648,784260,926090,673409,21741,730569,756349,713799,685778,756372,54702,897818,665301,848254,994680,859408,215318,685323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002489s ]