SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487595 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487595 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024452,428514,25023,535020,412347,836043,28226,741111,457133,808331,950550,787651,225373,225901,53241,58493,492107,397759,1006269,125982,473464,547359,665440,764318,839225,824964,889215,317660,410524,421558,246194,466428,489016,832073,913863,606425,466229,939845,533165,255312,64613,251969,169077,798325,1036813,599181,418013,660201,824731,252879,917833,120182,598862,602289,273294,583849,247536,881757,951885,649608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487595 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487595 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]