SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503821 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503821 [ RunTime:0.002068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796599,199531,444661,932945,731486,704850,919186,601585,909916,640188,762128,226760,262865,860103,586723,992486,691190,916821,404841,824093,449143,735721,171069,696999,89842,957640,525688,26310,671530,767223,329094,746480,515611,204308,273327,670428,874971,94759,52604,34087,61679,1033413,499409,853332,567129,706102,49857,980123,92043,122815,960464,247392,140467,498392,224273,818438,213243,225976,633418,284361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000754s ]