SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804038 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804038 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934510,258529,602266,76849,320648,307238,364679,987773,384957,673162,315999,851227,453998,802889,428508,197538,813282,516153,743248,973097,134471,251584,506437,707115,929076,573660,380478,960670,442061,316256,388672,904483,911630,961797,647245,877474,93229,765800,262544,279073,52561,889095,178502,926247,423138,690845,597463,140459,492778,402037,642050,832753,153059,414344,612359,513107,256597,90274,849083,820068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]