SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010515 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010515 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346900,246573,498209,711487,269664,384700,208381,687203,849000,594477,1500,791432,564357,930505,967328,239091,332748,393793,227561,773801,159508,904975,368548,946573,201523,108740,425833,235772,207062,514684,134963,264612,538366,413830,820091,186562,272471,917814,819918,946597,356799,296101,945518,906417,616473,843718,549271,43918,728276,764683,198453,471966,626428,928929,390486,400843,10017,961744,730799,501361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]