SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031864 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031864 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829147,851690,921021,669387,444576,820502,437930,665806,459218,601057,368530,669311,6064,238412,969030,141635,36064,893388,416816,132422,481710,997959,155411,221634,739959,232413,501183,659445,486797,587367,614255,570348,807305,411519,378578,498099,262208,455599,818657,821538,55749,61911,640518,788128,663954,207902,224781,221057,647214,87830,508182,166872,1018580,613033,458612,490385,501180,192121,706840,464927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001254s ]