SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590413 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590413 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297729,248427,440335,798699,948379,83944,811745,468149,704260,675544,201907,608205,20737,407149,880924,390416,1020638,842174,123204,768379,475753,1045392,166743,425472,681194,848398,385995,955522,496580,602647,336106,152949,516772,1039350,947727,334937,574526,128448,1016081,242471,44571,651036,64669,401668,51702,780771,869634,1021741,483989,724201,621519,94179,236328,514569,66396,894504,1008564,65585,872725,1034896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]