SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539751 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539751 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427701,501454,868973,557019,997073,337332,756972,543533,532409,712653,953909,121911,299149,715379,355537,932279,634017,884763,301002,584013,426939,140653,710137,939914,615934,169205,507342,237712,533129,578272,261837,141843,479535,28662,629111,1011039,391785,990691,624700,250297,453315,502545,1037174,843523,245053,51711,919394,297776,264956,399872,604027,964883,62041,959893,275864,408928,960173,965898,978021,905820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]